package com.example.demo.sql;

public class Constants {

    /**
     * 拼接条件的逻辑类型
     */
    public static String JOIN_STRING_AND = "AND";
    public static String JOIN_STRING_OR = "OR";


    /**
     * 比较运算符后的value类型
     */
    public static String VALUE_TYPE_STRING = "string";
    public static String VALUE_TYPE_NUMBER = "number";
    public static String VALUE_TYPE_COLLECTION = "collection";
    public static String VALUE_TYPE_SQL = "sql";
    public static String VALUE_TYPE_NULL = "null";


    /**
     * 比较运算符
     */
    public static String OPERATOR_EQ = "=";
    public static String OPERATOR_NE = "!=";
    public static String OPERATOR_GT = ">";
    public static String OPERATOR_LT = "<";
    public static String OPERATOR_GE = ">=";
    public static String OPERATOR_LE = "<=";
    public static String OPERATOR_LIKE = "LIKE";
    public static String OPERATOR_LIKE_LEFT = "";
    public static String OPERATOR_LIKE_RIGHT = "";
    public static String OPERATOR_NOT_LIKE = "NOT LIKE";
    public static String OPERATOR_BETWEEN = "BETWEEN";
    public static String OPERATOR_IN = "IN";
    public static String OPERATOR_NOT_IN = "NOT IN";
    public static String OPERATOR_IS_NULL = "IS NULL";
    public static String OPERATOR_IS_NOT_NULL = "IS NOT NULL";


    /**
     * 连接类型
     */
    public static String JOIN_TYPE_INNER_JOIN = "INNER JOIN";
    public static String JOIN_TYPE_LEFT_JOIN = "LEFT JOIN";
    public static String JOIN_TYPE_RIGHT_JOIN = "RIGHT JOIN";


    /**
     * rightValue的类型
     */
    public static String RIGHT_VALUE_TYPE_STRING = "STRING";
    public static String RIGHT_VALUE_TYPE_LONG = "LONG";
    public static String RIGHT_VALUE_TYPE_DOUBLE = "DOUBLE";
    public static String RIGHT_VALUE_TYPE_COLLECTION = "COLLECTION";
    public static String RIGHT_VALUE_TYPE_SQL = "SQL";
    public static String RIGHT_VALUE_TYPE_COLUMN = "COLUMN";

}
